﻿CREATE TABLE [dbo].[DBStrategies] (
    [ID]           UNIQUEIDENTIFIER DEFAULT (newid()) NOT NULL,
    [Name]         VARCHAR (255)    NOT NULL,
    [Pattern]      VARCHAR (255)    NOT NULL,
    [Version]      VARCHAR (26)     NOT NULL,
    [CreationDate] DATETIME         NOT NULL,
    [Info]         VARCHAR (255)    NULL,
    [CashEquity]   FLOAT            NULL,
    [MaxBias]      FLOAT            NULL,
    [MaxDrawDown]  FLOAT            NULL,
    [BuildAt]      TIME				NOT NULL,
    [UnBuildAt]    TIME				NOT NULL,
    PRIMARY KEY CLUSTERED ([ID] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF),
    UNIQUE NONCLUSTERED ([Pattern] ASC, [Name] ASC, [Version] ASC, [Info] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF)
);

